<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta name="viewport" content="width=device-width, initial-scale=1.0">
  <title>Document</title>
</head>
<body>
  <script>
     const list = [
            {
                correctionTime: "2018-11-30",
                departmentName: "总裁办",
                formOfEmployment: 1,
                id: "604f764971f93f3ac8f365c2",
                mobile: "13800000002",
                password: "e10adc3949ba59abbe56e057f20f883e",
                staffPhoto: "http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907",
                timeOfEntry: "2018-11-02",
                username: "管理员",
                workNumber: "9002",
            },
            {
                correctionTime: "2018-11-20",
                departmentName: "市场部",
                formOfEmployment: 1,
                id: "604f764971f93f3ac8f365c3",
                mobile: "13800000003",
                password: "e10adc3949ba59abbe56e057f20f883e",
                staffPhoto: "http://q6cu3t6jv.bkt.clouddn.com/1063705989926227968?t=1616204161907",
                timeOfEntry: "2018-11-04",
                username: "孙财",
                workNumber: "111",
            }
        ] 

        function transZhKeyToExcel(list) {
          const mapInfo = {
                  'id': '编号',
                  'password': '密码',
                  'mobile': '手机号',
                  'username': '姓名',
                  'timeOfEntry': '入职日期',
                  'formOfEmployment': '聘用形式',
                  'correctionTime': '转正日期',
                  'workNumber': '工号',
                  'departmentName': '部门',
                  'staffPhoto': '头像地址'
              }
              
          const one = list[0]
          if(!one) return
          const tHeader = Object.keys(one).map(enKey => mapInfo[enKey])
          // console.log(tHeader)
          const data = list.map(item => Object.values(item))
          // console.log(data)
          return {tHeader,data}
        }
        const {tHeader,data} = transZhKeyToExcel(list)
        console.log(tHeader)
        console.log(data)
  </script>
</body>
</html>